﻿CREATE TABLE [dbo].[dscGateway_Patient] (
    [PatientID]               INT           IDENTITY (1, 1) NOT NULL,
    [ID]                      VARCHAR (50)  NOT NULL,
    [Name]                    VARCHAR (100) NOT NULL,
    [Sex]                     VARCHAR (2)   NOT NULL,
    [BirthDateTime]           DATETIME      NOT NULL,
    [BreedDescription]        VARCHAR (50)  NULL,
    [BreedCodeSequenceCM]     VARCHAR (50)  NULL,
    [BreedCodeSequenceCV]     VARCHAR (50)  NULL,
    [BreedCodeSequenceCSD]    VARCHAR (50)  NULL,
    [SpeciesDescription]      VARCHAR (50)  NULL,
    [SpeciesCodeSequenceCM]   VARCHAR (50)  NULL,
    [SpeciesCodeSequenceCV]   VARCHAR (50)  NULL,
    [SpeciesCodeSequenceCSD]  VARCHAR (50)  NULL,
    [ResponsibleOrganization] VARCHAR (50)  NULL,
    [IDServer]                INT           NOT NULL,
    CONSTRAINT [PK_dscGateway] PRIMARY KEY CLUSTERED ([PatientID] ASC),
    CONSTRAINT [FK_dscGateway_Patient_dscGateway_Servers] FOREIGN KEY ([IDServer]) REFERENCES [dbo].[dscGateway_Servers] ([IDServer])
);

